Mega Code Archive - Oracle PLSQL Tutorial

Cursor
1) %ISOPEN, %FOUND, %NOTFOUND variables arent useful at all in CURSOR FOR loops
2) A complete example of using SELECT FOR UPDATE cursors
3) A complete example of using the cursorValue cursor
4) A Cursor for counting
5) A loop is required is to read each row in cursor returned
6) A PLSQL function that uses a cursor expression
7) Accessing Status Info by Using Cursor Variables
8) Adding an Exception Handler to a CURSOR FOR Loop
9) An example of cursor variable assignment
10) An example of cursor variable using %ROWCOUNT
11) An example of cursorValue cursor using %ISOPEN
12) An example of opening a cursor variable
13) An example of opening the cursorValue cursor
14) An example of parameterized cursor using cursor FOR LOOP
15) An example of using SYS_REFCURSOR for cursor variable processing
16) An example to illustrate parameterized cursors and cursorValue%NOTFOUND
17) Assigning different queries to the same cursor variable
18) Check error code and Raise the proper error
19) Check sql%rowcount
20) Checking the status of explicit cursors
21) Checking the status of implicit cursors
22) Close a cursor
23) Close cursor after while loop
24) Close cursor in excpetion handler
25) Compare the performance differences between row-at-a-time processing and bulk processing
26) Correct Code to Exit a Loop
27) Correctly Written Explicit Cursors
28) Create a cursor for update
29) Create and use reference cursor
30) Creating a REF CURSOR datatype
31) Cursor bulk
32) Cursor expressions as arguments to functions called from SQL
33) Cursor expressions using multiple levels of nested cursors
34) Cursor for aggregate function
35) Cursor FOR Loop
36) Cursor for object table
37) Cursor for update
38) Cursor FOR UPDATE NOWAIT
39) Cursor function
40) Cursor not found
41) Cursor performance
42) Cursor rowid
43) Cursor to reference whole table
44) Cursor with order by
45) Cursors
46) Declare and use a cursor in for loop
47) Declare cursor
48) Declaring a Cursor within a Procedure
49) Define refcursor variable
50) Defining a Cursor in an Anonymous PLSQL Block
51) Defining a Record Type for a Cursor by Using %ROWTYPE
52) Defining cursors in the package body
53) Defining cursors in the package specification
54) Exit a LOOP when cursor%NOTFOUND
55) Explicit cursor with cursor variable
56) Fetch cursor till cursorName%NOTFOUND
57) Fetch cursor till notfound
58) Fetch cursor to table collection of row type
59) Fetch cursor to three variables
60) Fetch cursor value into column type variable
61) Fetch cursor value to three variables
62) Fetch data into PLSQL table
63) Fetch row by row
64) Fetching Across Commits
65) Fetching Across Commits, Example 2
66) First Cursor Example
67) For data in ( select from tableName )
68) Handling exceptions in implicit cursors
69) Implicit Cursor
70) Implicit Cursor Attributes
71) Implicit Cursor Attributes Example
72) Implicit cursor open, fetch and close
73) Knowing what record is processing
74) LOOP END LOOP Cursor Loop
75) Loop till exit when cursorName%notfound
76) Looping through a Cursor by Using the LOOP Command
77) Nested cursor
78) Nested cursor open
79) NO_DATA_FOUND Exception vs %NOTFOUND
80) OPEN Cursor for fetching
81) Open cursor with a dynamic select statement
82) Open cursor with parameter
83) Open SYS_REFCURSOR for select from
84) Opening multiple queries using the same cursor variable
85) Output value in a refcursor
86) Parameterized cursor
87) Passing data from one table function to another in a pipelined fashion
88) Passing parameters to cursors
89) Placing cursors in nested loops
90) Populating a Record with FETCH INTO
91) Raise no data found exception if cursor is empty
92) REF CURSOR custom type
93) Reference cursor
94) Reference cursor type
95) Reference cursor variable
96) Reference value in a cursor by cursor variable
97) Return information using cursor status variables
98) Return sys_refcursor from a function
99) Returning an implicit cursor into a record
100) Returning more than one piece of information
101) Row type Reference cursor
102) Select column value into a cursor variable
103) Select first row to a cursor
104) Sql%notfound
105) Subprograms returning resultsets by using SYS_REFCURSOR
106) SYS_REFCURSOR as parameter
107) SYS_REFCURSOR type parameter
108) Taking a Shortcut with CURSOR FOR Loops
109) Test cursor attributes with an implicit cursor
110) The Difference between Explicit and Implicit Cursors
111) The use of REF CURSOR
112) Timing a ref cursor
113) To determine when the loop is to end, you can use the Boolean variable cursorName%NOTFOUND
114) To lock all the records while youre working on them This is done using a SELECT FOR UPDATE command
115) To prepare the comma-separated list
116) Use %ROWCOUNT to detect what record you are processing at a given point
117) Use cursor variables
118) Use explicit cursor to fetch and store value to number variable
119) Use For loop to output data in a PLSQL table of cursor
120) Use implicit or explicit cursor to insert 50000 rows to a table
121) Use the cursor subquery
122) Using %ROWCOUNT as an incremental rowcount
123) Using a simple UPDATE statement without locking for rows fetched from Cursors
124) Using SELECT in a Cursor
125) Using SQL%BULK_ROWCOUNT and SQL%ROWCOUNT
126) Using WHERE CURRENT OF
127) VARRAY of Cursor
128) When cursorName%NOTFOUND
129) WHILE LOOP Cursor Loop
130) While cursorName%found, loop
131) While cursorVariable%found loop